Forum Discussion

Johan_de_Rooij's avatar
Johan_de_Rooij
Copper Contributor
Oct 03, 2019

How can I import tasks in Microsoft To Do ? (urgent)

I have to import a large number of tasks from TodoIst (or CSV)

  • Johan_de_Rooij 

    I’ve solved it!

    I’ve long had a frustration with the fact that MS To-do does not have the ability to import mass tasks from excel like Wunderlist did, and every attempt to search up a solution just led me to posts with the same complaint, and no solution. However, there is a way to do it – through Outlook instead.

    To do this, you must be signed in to Outlook on a desktop – as far as I know this will not work on the web version. On the bottom left there is a tab to navigate to the “Tasks” page – click on this. If you are signed in to the correct MS account, your To-do list should be synced to this page. Find the list you want to upload to, and make sure there is at least one filler task in their for the time being so that you have a template to work from. Then, go to file > Open and export > Import/Export > Export to a file > Comma Separated Values > select your desired folder/list > save the file. Then you can go in and open that file, and add your tasks according to the template that was downloaded. Remember to save this as a CSV!

    After you have edited and saved your CSV, go to file > Open and export > Import/Export > Import from another program or file > Comma Separated Values > Select your file > select your desired folder/list > **Check that the box is clicked** > import your tasks!

    **if the box is not clicked, click it, and it will (Likely) bring you to a page to “map custom fields”. Don’t just skip past this, if it is showing up it probably means that something about your template got a little messed up and its not quite sure what to import, and to where. Verify that every category on the right-hand “to” column has the correct column header connected to it, and if not, fix it by dragging and dropping from the left hand column.

     

    NOTE: I am not a MS expert! I just found a solution that works, and this is the sequence of events that got me there. Hopefully it works for you!

    • tedpenner's avatar
      tedpenner
      Copper Contributor

      Sofia_Melchert 

       

      You suggested that in order to import tasks to Microsoft To-Do, I could import as CSV but that does not appear to be an option here.  Further assistance is greatly appreciated.

       

       

    • Todd_Ricker's avatar
      Todd_Ricker
      Copper Contributor

      I have long feared making the jump to a new task app. Thank you Sofia_Melchert for this genius tutorial. It worked flawlessly to take my world of tasks in the declining Toodledo and bring them into Microsoft. Thank you!  

  • tmac2k's avatar
    tmac2k
    Copper Contributor
    If you're on Windows, and you can get your tasks into Excel, and if you just care about the task names and not attachments, you can just copy a column full of tasks in Excel, and paste them into the To Do desktop app and it will create all your tasks at once (as separate items as expected).
    • cerebro84's avatar
      cerebro84
      Copper Contributor

      tmac2kBrilliant! I just tried it on Ubuntu with a free Office alternative Calc and To Do on Firefox and works as well!

  • You can do this with Flow, but only for yourself, there is no bulk import tool that can do this. But there is a Create to-do flow action that you can loop through from a CSV file that you feed to the flow via OneDrive.
  • Lewis-H's avatar
    Lewis-H
    Iron Contributor

    Johan_de_Rooij 

    Import your Wunderlist account to Microsoft To Do
    1. Head to Settings and select Import.
    2. Sign in to your Wunderlist account.
    3. Once you've signed in, we'll show you the number of lists and tasks that will be imported from your Wunderlist account to Microsoft To Do. ...
    4. Select Import begin moving your lists and tasks over from Wunderlist to Microsoft To Do.
    • Jim_1314's avatar
      Jim_1314
      Copper Contributor

      Lewis-H Please forgive my ignorance to your previous responses. Can you tell me how to import my Omnifocus tasks into Microsoft To-Do?

  • BenR00002145's avatar
    BenR00002145
    Brass Contributor
    I just flipped on the "coming soon" features of the MS Outlook desktop app and restarted. This is Summer of 2021, it might require enrolling in insider for office for those interested.

    It looks like To Do is now much more integrated into Outlook. A simple copy-paste and my data is in. I would expect import options to be smoother as well.

Resources